﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="Accounting3DataSet" targetNamespace="http://tempuri.org/Accounting3DataSet.xsd" xmlns:mstns="http://tempuri.org/Accounting3DataSet.xsd" xmlns="http://tempuri.org/Accounting3DataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="Accounting3ConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="Accounting3ConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.ReportGenerators.Properties.Settings.GlobalReference.Default.Accounting3ConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TaiSanCoDinhTableAdapter" GeneratorDataComponentClassName="TaiSanCoDinhTableAdapter" Name="TaiSanCoDinh" UserDataComponentName="TaiSanCoDinhTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Accounting3ConnectionString (Settings)" DbObjectName="Accounting3.dbo.TaiSanCoDinh" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[TaiSanCoDinh] WHERE (([TaiSanCoDinhID] = @Original_TaiSanCoDinhID) AND ([LoaiTaiSanCoDinhID] = @Original_LoaiTaiSanCoDinhID) AND ([Ma] = @Original_Ma) AND ([Ten] = @Original_Ten) AND ([SoThe] = @Original_SoThe) AND ([SoBienBanGiaoNhan] = @Original_SoBienBanGiaoNhan) AND ((@IsNull_NgayGiaoNhan = 1 AND [NgayGiaoNhan] IS NULL) OR ([NgayGiaoNhan] = @Original_NgayGiaoNhan)) AND ([DonViTinh] = @Original_DonViTinh) AND ([NuocSanXuat] = @Original_NuocSanXuat) AND ([NamSanXuat] = @Original_NamSanXuat) AND ([CongSuat] = @Original_CongSuat) AND ([PhongBanSuDungID] = @Original_PhongBanSuDungID) AND ([SoThangTinhKhauHao] = @Original_SoThangTinhKhauHao) AND ((@IsNull_NgayBatDauKhauHao = 1 AND [NgayBatDauKhauHao] IS NULL) OR ([NgayBatDauKhauHao] = @Original_NgayBatDauKhauHao)) AND ((@IsNull_NgayThoiKhauHao = 1 AND [NgayThoiKhauHao] IS NULL) OR ([NgayThoiKhauHao] = @Original_NgayThoiKhauHao)) AND ([NguyenGia] = @Original_NguyenGia) AND ([GiaTriTinhKhauHao] = @Original_GiaTriTinhKhauHao) AND ([HaoMonLuyKeDauKy] = @Original_HaoMonLuyKeDauKy) AND ([TaiKhoanNguyenGiaID] = @Original_TaiKhoanNguyenGiaID) AND ([TaiKhoanNoKhauHaoID] = @Original_TaiKhoanNoKhauHaoID) AND ([TaiKhoanCoKhauHaoID] = @Original_TaiKhoanCoKhauHaoID) AND ((@IsNull_VuViecID = 1 AND [VuViecID] IS NULL) OR ([VuViecID] = @Original_VuViecID)) AND ((@IsNull_YeuToChiPhiID = 1 AND [YeuToChiPhiID] IS NULL) OR ([YeuToChiPhiID] = @Original_YeuToChiPhiID)) AND ([TrangThaiID] = @Original_TrangThaiID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TaiSanCoDinhID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TaiSanCoDinhID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_LoaiTaiSanCoDinhID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LoaiTaiSanCoDinhID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Ma" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Ten" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Ten" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_SoThe" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SoThe" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_SoBienBanGiaoNhan" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SoBienBanGiaoNhan" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NgayGiaoNhan" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NgayGiaoNhan" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_NgayGiaoNhan" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="NgayGiaoNhan" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DonViTinh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DonViTinh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_NuocSanXuat" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NuocSanXuat" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_NamSanXuat" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NamSanXuat" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CongSuat" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CongSuat" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PhongBanSuDungID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PhongBanSuDungID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_SoThangTinhKhauHao" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SoThangTinhKhauHao" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NgayBatDauKhauHao" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NgayBatDauKhauHao" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_NgayBatDauKhauHao" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="NgayBatDauKhauHao" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NgayThoiKhauHao" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NgayThoiKhauHao" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_NgayThoiKhauHao" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="NgayThoiKhauHao" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_NguyenGia" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="NguyenGia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_GiaTriTinhKhauHao" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="GiaTriTinhKhauHao" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_HaoMonLuyKeDauKy" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="HaoMonLuyKeDauKy" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TaiKhoanNguyenGiaID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TaiKhoanNguyenGiaID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TaiKhoanNoKhauHaoID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TaiKhoanNoKhauHaoID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TaiKhoanCoKhauHaoID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TaiKhoanCoKhauHaoID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_VuViecID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="VuViecID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_VuViecID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="VuViecID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_YeuToChiPhiID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="YeuToChiPhiID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_YeuToChiPhiID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="YeuToChiPhiID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TrangThaiID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TrangThaiID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[TaiSanCoDinh] ([LoaiTaiSanCoDinhID], [Ma], [Ten], [SoThe], [SoBienBanGiaoNhan], [NgayGiaoNhan], [DonViTinh], [NuocSanXuat], [NamSanXuat], [CongSuat], [PhongBanSuDungID], [SoThangTinhKhauHao], [NgayBatDauKhauHao], [NgayThoiKhauHao], [NguyenGia], [GiaTriTinhKhauHao], [HaoMonLuyKeDauKy], [TaiKhoanNguyenGiaID], [TaiKhoanNoKhauHaoID], [TaiKhoanCoKhauHaoID], [VuViecID], [YeuToChiPhiID], [TrangThaiID]) VALUES (@LoaiTaiSanCoDinhID, @Ma, @Ten, @SoThe, @SoBienBanGiaoNhan, @NgayGiaoNhan, @DonViTinh, @NuocSanXuat, @NamSanXuat, @CongSuat, @PhongBanSuDungID, @SoThangTinhKhauHao, @NgayBatDauKhauHao, @NgayThoiKhauHao, @NguyenGia, @GiaTriTinhKhauHao, @HaoMonLuyKeDauKy, @TaiKhoanNguyenGiaID, @TaiKhoanNoKhauHaoID, @TaiKhoanCoKhauHaoID, @VuViecID, @YeuToChiPhiID, @TrangThaiID);
SELECT TaiSanCoDinhID, LoaiTaiSanCoDinhID, Ma, Ten, SoThe, SoBienBanGiaoNhan, NgayGiaoNhan, DonViTinh, NuocSanXuat, NamSanXuat, CongSuat, PhongBanSuDungID, SoThangTinhKhauHao, NgayBatDauKhauHao, NgayThoiKhauHao, NguyenGia, GiaTriTinhKhauHao, HaoMonLuyKeDauKy, TaiKhoanNguyenGiaID, TaiKhoanNoKhauHaoID, TaiKhoanCoKhauHaoID, VuViecID, YeuToChiPhiID, TrangThaiID FROM TaiSanCoDinh WHERE (TaiSanCoDinhID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@LoaiTaiSanCoDinhID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LoaiTaiSanCoDinhID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Ma" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Ten" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Ten" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@SoThe" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SoThe" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@SoBienBanGiaoNhan" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SoBienBanGiaoNhan" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@NgayGiaoNhan" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="NgayGiaoNhan" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DonViTinh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DonViTinh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@NuocSanXuat" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NuocSanXuat" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@NamSanXuat" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NamSanXuat" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CongSuat" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CongSuat" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@PhongBanSuDungID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PhongBanSuDungID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@SoThangTinhKhauHao" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SoThangTinhKhauHao" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@NgayBatDauKhauHao" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="NgayBatDauKhauHao" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@NgayThoiKhauHao" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="NgayThoiKhauHao" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@NguyenGia" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="NguyenGia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@GiaTriTinhKhauHao" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="GiaTriTinhKhauHao" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@HaoMonLuyKeDauKy" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="HaoMonLuyKeDauKy" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@TaiKhoanNguyenGiaID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TaiKhoanNguyenGiaID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@TaiKhoanNoKhauHaoID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TaiKhoanNoKhauHaoID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@TaiKhoanCoKhauHaoID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TaiKhoanCoKhauHaoID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@VuViecID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="VuViecID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@YeuToChiPhiID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="YeuToChiPhiID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@TrangThaiID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TrangThaiID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT TaiSanCoDinhID, LoaiTaiSanCoDinhID, Ma, Ten, SoThe, SoBienBanGiaoNhan, NgayGiaoNhan, DonViTinh, NuocSanXuat, NamSanXuat, CongSuat, PhongBanSuDungID, SoThangTinhKhauHao, NgayBatDauKhauHao, NgayThoiKhauHao, NguyenGia, GiaTriTinhKhauHao, HaoMonLuyKeDauKy, TaiKhoanNguyenGiaID, TaiKhoanNoKhauHaoID, TaiKhoanCoKhauHaoID, VuViecID, YeuToChiPhiID, TrangThaiID FROM dbo.TaiSanCoDinh</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[TaiSanCoDinh] SET [LoaiTaiSanCoDinhID] = @LoaiTaiSanCoDinhID, [Ma] = @Ma, [Ten] = @Ten, [SoThe] = @SoThe, [SoBienBanGiaoNhan] = @SoBienBanGiaoNhan, [NgayGiaoNhan] = @NgayGiaoNhan, [DonViTinh] = @DonViTinh, [NuocSanXuat] = @NuocSanXuat, [NamSanXuat] = @NamSanXuat, [CongSuat] = @CongSuat, [PhongBanSuDungID] = @PhongBanSuDungID, [SoThangTinhKhauHao] = @SoThangTinhKhauHao, [NgayBatDauKhauHao] = @NgayBatDauKhauHao, [NgayThoiKhauHao] = @NgayThoiKhauHao, [NguyenGia] = @NguyenGia, [GiaTriTinhKhauHao] = @GiaTriTinhKhauHao, [HaoMonLuyKeDauKy] = @HaoMonLuyKeDauKy, [TaiKhoanNguyenGiaID] = @TaiKhoanNguyenGiaID, [TaiKhoanNoKhauHaoID] = @TaiKhoanNoKhauHaoID, [TaiKhoanCoKhauHaoID] = @TaiKhoanCoKhauHaoID, [VuViecID] = @VuViecID, [YeuToChiPhiID] = @YeuToChiPhiID, [TrangThaiID] = @TrangThaiID WHERE (([TaiSanCoDinhID] = @Original_TaiSanCoDinhID) AND ([LoaiTaiSanCoDinhID] = @Original_LoaiTaiSanCoDinhID) AND ([Ma] = @Original_Ma) AND ([Ten] = @Original_Ten) AND ([SoThe] = @Original_SoThe) AND ([SoBienBanGiaoNhan] = @Original_SoBienBanGiaoNhan) AND ((@IsNull_NgayGiaoNhan = 1 AND [NgayGiaoNhan] IS NULL) OR ([NgayGiaoNhan] = @Original_NgayGiaoNhan)) AND ([DonViTinh] = @Original_DonViTinh) AND ([NuocSanXuat] = @Original_NuocSanXuat) AND ([NamSanXuat] = @Original_NamSanXuat) AND ([CongSuat] = @Original_CongSuat) AND ([PhongBanSuDungID] = @Original_PhongBanSuDungID) AND ([SoThangTinhKhauHao] = @Original_SoThangTinhKhauHao) AND ((@IsNull_NgayBatDauKhauHao = 1 AND [NgayBatDauKhauHao] IS NULL) OR ([NgayBatDauKhauHao] = @Original_NgayBatDauKhauHao)) AND ((@IsNull_NgayThoiKhauHao = 1 AND [NgayThoiKhauHao] IS NULL) OR ([NgayThoiKhauHao] = @Original_NgayThoiKhauHao)) AND ([NguyenGia] = @Original_NguyenGia) AND ([GiaTriTinhKhauHao] = @Original_GiaTriTinhKhauHao) AND ([HaoMonLuyKeDauKy] = @Original_HaoMonLuyKeDauKy) AND ([TaiKhoanNguyenGiaID] = @Original_TaiKhoanNguyenGiaID) AND ([TaiKhoanNoKhauHaoID] = @Original_TaiKhoanNoKhauHaoID) AND ([TaiKhoanCoKhauHaoID] = @Original_TaiKhoanCoKhauHaoID) AND ((@IsNull_VuViecID = 1 AND [VuViecID] IS NULL) OR ([VuViecID] = @Original_VuViecID)) AND ((@IsNull_YeuToChiPhiID = 1 AND [YeuToChiPhiID] IS NULL) OR ([YeuToChiPhiID] = @Original_YeuToChiPhiID)) AND ([TrangThaiID] = @Original_TrangThaiID));
SELECT TaiSanCoDinhID, LoaiTaiSanCoDinhID, Ma, Ten, SoThe, SoBienBanGiaoNhan, NgayGiaoNhan, DonViTinh, NuocSanXuat, NamSanXuat, CongSuat, PhongBanSuDungID, SoThangTinhKhauHao, NgayBatDauKhauHao, NgayThoiKhauHao, NguyenGia, GiaTriTinhKhauHao, HaoMonLuyKeDauKy, TaiKhoanNguyenGiaID, TaiKhoanNoKhauHaoID, TaiKhoanCoKhauHaoID, VuViecID, YeuToChiPhiID, TrangThaiID FROM TaiSanCoDinh WHERE (TaiSanCoDinhID = @TaiSanCoDinhID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@LoaiTaiSanCoDinhID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LoaiTaiSanCoDinhID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Ma" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Ten" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Ten" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@SoThe" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SoThe" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@SoBienBanGiaoNhan" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SoBienBanGiaoNhan" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@NgayGiaoNhan" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="NgayGiaoNhan" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DonViTinh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DonViTinh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@NuocSanXuat" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NuocSanXuat" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@NamSanXuat" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NamSanXuat" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CongSuat" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CongSuat" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@PhongBanSuDungID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PhongBanSuDungID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@SoThangTinhKhauHao" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SoThangTinhKhauHao" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@NgayBatDauKhauHao" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="NgayBatDauKhauHao" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@NgayThoiKhauHao" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="NgayThoiKhauHao" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@NguyenGia" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="NguyenGia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@GiaTriTinhKhauHao" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="GiaTriTinhKhauHao" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@HaoMonLuyKeDauKy" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="HaoMonLuyKeDauKy" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@TaiKhoanNguyenGiaID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TaiKhoanNguyenGiaID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@TaiKhoanNoKhauHaoID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TaiKhoanNoKhauHaoID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@TaiKhoanCoKhauHaoID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TaiKhoanCoKhauHaoID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@VuViecID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="VuViecID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@YeuToChiPhiID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="YeuToChiPhiID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@TrangThaiID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TrangThaiID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TaiSanCoDinhID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TaiSanCoDinhID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_LoaiTaiSanCoDinhID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LoaiTaiSanCoDinhID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Ma" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Ten" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Ten" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_SoThe" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SoThe" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_SoBienBanGiaoNhan" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SoBienBanGiaoNhan" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NgayGiaoNhan" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NgayGiaoNhan" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_NgayGiaoNhan" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="NgayGiaoNhan" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DonViTinh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DonViTinh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_NuocSanXuat" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NuocSanXuat" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_NamSanXuat" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NamSanXuat" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CongSuat" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CongSuat" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PhongBanSuDungID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PhongBanSuDungID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_SoThangTinhKhauHao" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SoThangTinhKhauHao" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NgayBatDauKhauHao" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NgayBatDauKhauHao" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_NgayBatDauKhauHao" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="NgayBatDauKhauHao" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NgayThoiKhauHao" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NgayThoiKhauHao" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_NgayThoiKhauHao" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="NgayThoiKhauHao" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_NguyenGia" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="NguyenGia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_GiaTriTinhKhauHao" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="GiaTriTinhKhauHao" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_HaoMonLuyKeDauKy" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="HaoMonLuyKeDauKy" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TaiKhoanNguyenGiaID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TaiKhoanNguyenGiaID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TaiKhoanNoKhauHaoID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TaiKhoanNoKhauHaoID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TaiKhoanCoKhauHaoID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TaiKhoanCoKhauHaoID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_VuViecID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="VuViecID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_VuViecID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="VuViecID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_YeuToChiPhiID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="YeuToChiPhiID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_YeuToChiPhiID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="YeuToChiPhiID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TrangThaiID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TrangThaiID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="TaiSanCoDinhID" ColumnName="TaiSanCoDinhID" DataSourceName="Accounting3.dbo.TaiSanCoDinh" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@TaiSanCoDinhID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="TaiSanCoDinhID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="TaiSanCoDinhID" DataSetColumn="TaiSanCoDinhID" />
              <Mapping SourceColumn="LoaiTaiSanCoDinhID" DataSetColumn="LoaiTaiSanCoDinhID" />
              <Mapping SourceColumn="Ma" DataSetColumn="Ma" />
              <Mapping SourceColumn="Ten" DataSetColumn="Ten" />
              <Mapping SourceColumn="SoThe" DataSetColumn="SoThe" />
              <Mapping SourceColumn="SoBienBanGiaoNhan" DataSetColumn="SoBienBanGiaoNhan" />
              <Mapping SourceColumn="NgayGiaoNhan" DataSetColumn="NgayGiaoNhan" />
              <Mapping SourceColumn="DonViTinh" DataSetColumn="DonViTinh" />
              <Mapping SourceColumn="NuocSanXuat" DataSetColumn="NuocSanXuat" />
              <Mapping SourceColumn="NamSanXuat" DataSetColumn="NamSanXuat" />
              <Mapping SourceColumn="CongSuat" DataSetColumn="CongSuat" />
              <Mapping SourceColumn="PhongBanSuDungID" DataSetColumn="PhongBanSuDungID" />
              <Mapping SourceColumn="SoThangTinhKhauHao" DataSetColumn="SoThangTinhKhauHao" />
              <Mapping SourceColumn="NgayBatDauKhauHao" DataSetColumn="NgayBatDauKhauHao" />
              <Mapping SourceColumn="NgayThoiKhauHao" DataSetColumn="NgayThoiKhauHao" />
              <Mapping SourceColumn="NguyenGia" DataSetColumn="NguyenGia" />
              <Mapping SourceColumn="GiaTriTinhKhauHao" DataSetColumn="GiaTriTinhKhauHao" />
              <Mapping SourceColumn="HaoMonLuyKeDauKy" DataSetColumn="HaoMonLuyKeDauKy" />
              <Mapping SourceColumn="TaiKhoanNguyenGiaID" DataSetColumn="TaiKhoanNguyenGiaID" />
              <Mapping SourceColumn="TaiKhoanNoKhauHaoID" DataSetColumn="TaiKhoanNoKhauHaoID" />
              <Mapping SourceColumn="TaiKhoanCoKhauHaoID" DataSetColumn="TaiKhoanCoKhauHaoID" />
              <Mapping SourceColumn="VuViecID" DataSetColumn="VuViecID" />
              <Mapping SourceColumn="YeuToChiPhiID" DataSetColumn="YeuToChiPhiID" />
              <Mapping SourceColumn="TrangThaiID" DataSetColumn="TrangThaiID" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="Accounting3DataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_DataSetName="Accounting3DataSet" msprop:Generator_UserDSName="Accounting3DataSet" msprop:EnableTableAdapterManager="True">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="TaiSanCoDinh" msprop:Generator_UserTableName="TaiSanCoDinh" msprop:Generator_RowDeletedName="TaiSanCoDinhRowDeleted" msprop:Generator_TableClassName="TaiSanCoDinhDataTable" msprop:Generator_RowChangedName="TaiSanCoDinhRowChanged" msprop:Generator_RowClassName="TaiSanCoDinhRow" msprop:Generator_RowChangingName="TaiSanCoDinhRowChanging" msprop:Generator_RowEvArgName="TaiSanCoDinhRowChangeEvent" msprop:Generator_RowEvHandlerName="TaiSanCoDinhRowChangeEventHandler" msprop:Generator_TablePropName="TaiSanCoDinh" msprop:Generator_TableVarName="tableTaiSanCoDinh" msprop:Generator_RowDeletingName="TaiSanCoDinhRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="TaiSanCoDinhID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="TaiSanCoDinhID" msprop:Generator_ColumnPropNameInRow="TaiSanCoDinhID" msprop:Generator_ColumnVarNameInTable="columnTaiSanCoDinhID" msprop:Generator_ColumnPropNameInTable="TaiSanCoDinhIDColumn" type="xs:int" />
              <xs:element name="LoaiTaiSanCoDinhID" msprop:Generator_UserColumnName="LoaiTaiSanCoDinhID" msprop:Generator_ColumnPropNameInRow="LoaiTaiSanCoDinhID" msprop:Generator_ColumnVarNameInTable="columnLoaiTaiSanCoDinhID" msprop:Generator_ColumnPropNameInTable="LoaiTaiSanCoDinhIDColumn" type="xs:int" />
              <xs:element name="Ma" msprop:Generator_UserColumnName="Ma" msprop:Generator_ColumnPropNameInRow="Ma" msprop:Generator_ColumnVarNameInTable="columnMa" msprop:Generator_ColumnPropNameInTable="MaColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Ten" msprop:Generator_UserColumnName="Ten" msprop:Generator_ColumnPropNameInRow="Ten" msprop:Generator_ColumnVarNameInTable="columnTen" msprop:Generator_ColumnPropNameInTable="TenColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SoThe" msprop:Generator_UserColumnName="SoThe" msprop:Generator_ColumnPropNameInRow="SoThe" msprop:Generator_ColumnVarNameInTable="columnSoThe" msprop:Generator_ColumnPropNameInTable="SoTheColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SoBienBanGiaoNhan" msprop:Generator_UserColumnName="SoBienBanGiaoNhan" msprop:Generator_ColumnPropNameInRow="SoBienBanGiaoNhan" msprop:Generator_ColumnVarNameInTable="columnSoBienBanGiaoNhan" msprop:Generator_ColumnPropNameInTable="SoBienBanGiaoNhanColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NgayGiaoNhan" msprop:Generator_UserColumnName="NgayGiaoNhan" msprop:Generator_ColumnPropNameInRow="NgayGiaoNhan" msprop:Generator_ColumnVarNameInTable="columnNgayGiaoNhan" msprop:Generator_ColumnPropNameInTable="NgayGiaoNhanColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="DonViTinh" msprop:Generator_UserColumnName="DonViTinh" msprop:Generator_ColumnPropNameInRow="DonViTinh" msprop:Generator_ColumnVarNameInTable="columnDonViTinh" msprop:Generator_ColumnPropNameInTable="DonViTinhColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NuocSanXuat" msprop:Generator_UserColumnName="NuocSanXuat" msprop:Generator_ColumnPropNameInRow="NuocSanXuat" msprop:Generator_ColumnVarNameInTable="columnNuocSanXuat" msprop:Generator_ColumnPropNameInTable="NuocSanXuatColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NamSanXuat" msprop:Generator_UserColumnName="NamSanXuat" msprop:Generator_ColumnPropNameInRow="NamSanXuat" msprop:Generator_ColumnVarNameInTable="columnNamSanXuat" msprop:Generator_ColumnPropNameInTable="NamSanXuatColumn" type="xs:int" />
              <xs:element name="CongSuat" msprop:Generator_UserColumnName="CongSuat" msprop:Generator_ColumnPropNameInRow="CongSuat" msprop:Generator_ColumnVarNameInTable="columnCongSuat" msprop:Generator_ColumnPropNameInTable="CongSuatColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PhongBanSuDungID" msprop:Generator_UserColumnName="PhongBanSuDungID" msprop:Generator_ColumnPropNameInRow="PhongBanSuDungID" msprop:Generator_ColumnVarNameInTable="columnPhongBanSuDungID" msprop:Generator_ColumnPropNameInTable="PhongBanSuDungIDColumn" type="xs:int" />
              <xs:element name="SoThangTinhKhauHao" msprop:Generator_UserColumnName="SoThangTinhKhauHao" msprop:Generator_ColumnPropNameInRow="SoThangTinhKhauHao" msprop:Generator_ColumnVarNameInTable="columnSoThangTinhKhauHao" msprop:Generator_ColumnPropNameInTable="SoThangTinhKhauHaoColumn" type="xs:int" />
              <xs:element name="NgayBatDauKhauHao" msprop:Generator_UserColumnName="NgayBatDauKhauHao" msprop:Generator_ColumnPropNameInRow="NgayBatDauKhauHao" msprop:Generator_ColumnVarNameInTable="columnNgayBatDauKhauHao" msprop:Generator_ColumnPropNameInTable="NgayBatDauKhauHaoColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="NgayThoiKhauHao" msprop:Generator_UserColumnName="NgayThoiKhauHao" msprop:Generator_ColumnPropNameInRow="NgayThoiKhauHao" msprop:Generator_ColumnVarNameInTable="columnNgayThoiKhauHao" msprop:Generator_ColumnPropNameInTable="NgayThoiKhauHaoColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="NguyenGia" msprop:Generator_UserColumnName="NguyenGia" msprop:Generator_ColumnPropNameInRow="NguyenGia" msprop:Generator_ColumnVarNameInTable="columnNguyenGia" msprop:Generator_ColumnPropNameInTable="NguyenGiaColumn" type="xs:decimal" />
              <xs:element name="GiaTriTinhKhauHao" msprop:Generator_UserColumnName="GiaTriTinhKhauHao" msprop:Generator_ColumnPropNameInRow="GiaTriTinhKhauHao" msprop:Generator_ColumnVarNameInTable="columnGiaTriTinhKhauHao" msprop:Generator_ColumnPropNameInTable="GiaTriTinhKhauHaoColumn" type="xs:decimal" />
              <xs:element name="HaoMonLuyKeDauKy" msprop:Generator_UserColumnName="HaoMonLuyKeDauKy" msprop:Generator_ColumnPropNameInRow="HaoMonLuyKeDauKy" msprop:Generator_ColumnVarNameInTable="columnHaoMonLuyKeDauKy" msprop:Generator_ColumnPropNameInTable="HaoMonLuyKeDauKyColumn" type="xs:decimal" />
              <xs:element name="TaiKhoanNguyenGiaID" msprop:Generator_UserColumnName="TaiKhoanNguyenGiaID" msprop:Generator_ColumnPropNameInRow="TaiKhoanNguyenGiaID" msprop:Generator_ColumnVarNameInTable="columnTaiKhoanNguyenGiaID" msprop:Generator_ColumnPropNameInTable="TaiKhoanNguyenGiaIDColumn" type="xs:int" />
              <xs:element name="TaiKhoanNoKhauHaoID" msprop:Generator_UserColumnName="TaiKhoanNoKhauHaoID" msprop:Generator_ColumnPropNameInRow="TaiKhoanNoKhauHaoID" msprop:Generator_ColumnVarNameInTable="columnTaiKhoanNoKhauHaoID" msprop:Generator_ColumnPropNameInTable="TaiKhoanNoKhauHaoIDColumn" type="xs:int" />
              <xs:element name="TaiKhoanCoKhauHaoID" msprop:Generator_UserColumnName="TaiKhoanCoKhauHaoID" msprop:Generator_ColumnPropNameInRow="TaiKhoanCoKhauHaoID" msprop:Generator_ColumnVarNameInTable="columnTaiKhoanCoKhauHaoID" msprop:Generator_ColumnPropNameInTable="TaiKhoanCoKhauHaoIDColumn" type="xs:int" />
              <xs:element name="VuViecID" msprop:Generator_UserColumnName="VuViecID" msprop:Generator_ColumnPropNameInRow="VuViecID" msprop:Generator_ColumnVarNameInTable="columnVuViecID" msprop:Generator_ColumnPropNameInTable="VuViecIDColumn" type="xs:int" minOccurs="0" />
              <xs:element name="YeuToChiPhiID" msprop:Generator_UserColumnName="YeuToChiPhiID" msprop:Generator_ColumnPropNameInRow="YeuToChiPhiID" msprop:Generator_ColumnVarNameInTable="columnYeuToChiPhiID" msprop:Generator_ColumnPropNameInTable="YeuToChiPhiIDColumn" type="xs:int" minOccurs="0" />
              <xs:element name="TrangThaiID" msprop:Generator_UserColumnName="TrangThaiID" msprop:Generator_ColumnPropNameInRow="TrangThaiID" msprop:Generator_ColumnVarNameInTable="columnTrangThaiID" msprop:Generator_ColumnPropNameInTable="TrangThaiIDColumn" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:TaiSanCoDinh" />
      <xs:field xpath="mstns:TaiSanCoDinhID" />
    </xs:unique>
  </xs:element>
</xs:schema>